Skip to main content
Version: 9.3

Multiseries Symbol Chart

Use Multiseries Symbol Charts to present a single value in more than one category. Effectively, a multiseries chart consists of two dimensions and a measure. Users need to add a single Category, Value and Series field. For example, to show the number of orders in various statuses, across order months, you can add Shipped Date as Category, Quantity as Value, and Status as Series.

Multiseries Symbol Charts help visualize the highs and lows that appear in your data across the series. A Symbol Chart is very similar to a Bar Chart in its use case. As a result, a Multiseries Symbol Chart can be used in place of a Multiseries Bar Chart.

ms-symbol-chart

Create a Multiseries Symbol Chart

To create a Multiseries Symbol Chart, drag and drop a data field from the Data Panel onto either the corresponding shelf or the canvas.

The following use case visualizes the status of orders in relation to the quantity ordered and the country of the order.

  1. Drag and drop the following:

    • Country as Category
    • Quantity as Value
    • Status as Series
  2. Style the chart in the Configuration Panel.

ms-symbol-chart

If you have only one category to visualize, you can use a Symbol Chart.

Style the Multiseries Symbol Chart

In the Configuration Panel on the right of the Chart Builder, you can style different aspects of your chart.

General

The General section is available for all chart types, and the options vary depending on the chart selected.

Note: Use the Table Calculations option to add calculations to your Combo Chart. For more information, see Table Calculations.

Styles

The Styles section enables you to control various visual elements of the charts, such as colors, labels, and more. It is available for most chart types, and the options vary depending on the chart selected. Style options specific to this chart are listed below.

  • Theme - Select a theme to unify the look of your charts.

    • Match colors across charts - Select to Unify the colors of each categorical value throughout the page and application.
  • Axis Labels - Show or hide the labels of the axes.

  • Category axis (normally the X-axis)

    • Label - Give the axis a custom label.
    • Values - Show or hide values on the axis.
    • Values Rotation - If values are enabled, decide how you want them to be displayed.
  • Values axis (typically y axis)

    • Label - Give the axis a custom label.

    • Values - Show or hide values on the axis.

    • Values Rotation - If value labels are enabled, decide how you want them to be displayed. You can use this option to avoid overlapping labels.

    • Format - Set the format of the values choosing between Default, Abbreviated, Decimal (set the number of decimal points), Currency (choose the currency from the drop-down menu and set the number of decimal points), Percentage (set the number of decimal points), Scientific. Values can also be formatted from the Values column pill.

    • Scale Type - Default scale type is Linear; however, a linear scale is not appropriate for data that is spread over a wide range. Use the Logarithmic scale to display numerical data over a wide range of values in a compact way.

    • Min Range - Set the minimum value for the axis.

    • Max Range - Set the maximum value for the axis.

      • Steps - Depending on the width of the axis range, the default configuration could display many tick marks, affecting readability. Intervals are set to Auto by default, causing the chart to calculate the appropriate intervals based on the axis scale range and the dataset values. In the following example, the range of data is from 0 to 8,000. When you set the step to 1000 units, the chart displays eight tick marks. When set to 10,000, the chart display only 1 tick mark.

        ms-symbol-chart

        When the axis range is wide (for example, 0 - 10,000,000), setting the Steps option to 1 will create 10 million tick marks, causing performance issues. To avoid this situation, the chart ignores the defined value and reverts to automatic mode.

  • Symbol - Select a symbol type to display in your chart.

    ms-symbol-chart

  • Data Labels - Enable or disable data labels to show specific values directly on the chart for easier reference.

    • Borders - Control if the values displayed have a border or not.
  • Fill - Fill the symbol or display as an outline.

  • Offset - Determines the offset of the chart. Configure a manual offset as a Percentage or in Pixels, and enter values in the Left and Top/Bottom fields. To enable the platform to automatically manage the offsets, select Reset to Default to set the values under Left and Top/Bottom to Auto.

Sorting

Like all Multiseries Charts, you can sort by category or aggregated values from the column pills. If the column is not included in the chart, go to the Sorting section of the Configuration Panel and select a column from the dropdown, then select the sorting direction.

For more information, see Sorting.

Layer

Add a Trend Line or a Reference Line to your chart to allow users to visually compare the data against some set trend or reference value.

Format

The Small Multiples feature is available in all XY Charts. You can apply Conditional Formatting to your Multiseries Chart.

Filters

You can also add Filters to your data by expanding the Filters section in the configuration panel or by selecting the Filters button in the toolbar above the canvas. Filters that are created in the Chart Builder are hidden from end users. You cannot edit or interact with these filters in view mode.